To format letter merge data with field switches
You can apply the general switches available in Microsoft Word to your merge fields when using the Letter System to complete a letter merge from within iMIS. These switches allow you to modify the format of the data that results from the merge fields you add to your letter. Refer to your Microsoft Word documentation for detailed information about using switches to change the format of merged data.
Note: The switch must be placed after the "MERGEFIELD" but before the curly bracket }. For example { MERGEFIELD Name \* Caps }.
The numeric picture (\#) and format (\*) switches are the two most common types of switches used in merging letters. The following are options available when using these two switches to modify your merge data:
\# - Numeric Picture
Use this switch to specify the display of a numeric result, including the number of decimal places and the use of currency symbols.
0 - (zero) Indicates the number of decimal places to display
# - Indicates the number of spaces to display
$ - Indicates to include the specified character in the result
. - (decimal point) Indicates the decimal point position
, - (comma, digit grouping symbol) Indicates where to separates a series of three digits
For example, if the {SubscriptionsBILL_AMOUNT} merge field results in a value of 100, changing the field to {SubscriptionsBILL_AMOUNT \# $#,0.00} results in a value of $100.00 displaying for the result.
\* - Formats
Use this switch to specify number formats, capitalization, and character formatting; prevents changes to the format of the field results when a field is updated.
\* Charformat - Apply the formatting of the first letter of the field type to the entire result
\* Caps - Indicates the first letter of each word should display as a capital letter
\* FirstCap - Indicates the first letter of only the first word should display as a capital letter
\* Upper - Indicates all the letters should be capitalized
\* Lower - Indicates all the letters should be lowercase
For example, if the {NameFULL_NAME} merge field results in a value of Ms. Jean D. Smythe, changing the field to {NameFULL_NAME \* Upper} results in a value of MS. JEAN D. SMYTHE.
Note: The merge format options discussed in this section must be performed before you merge the data.
Note: The Available Reports list is empty. Letter reports are selected on the Membership Standard Letters window.
Note: The switch should be placed after the "MERGEFIELD" but before the curly bracket }. For example { MERGEFIELD Name \* Caps }.
10.6 Production Release. Updated 10/5/2005 3:49:46 PM
© 2009 by Advanced Solutions International, Inc.
All rights reserved.